Two fairly simple scripts to run to set:
Public Access in Objects checked ON 100%
Public Access in Media checked OFF 100%

(back up your database first, please)

--Set ALL Objects have PublicAccess checked
Update Objects
Set PublicAccess = 1
Where ObjectID <> -1
GO


--Set ALL Media records to have PublicAccess UNchecked
Update MediaMaster
Set PublicAccess = 0
GO

To unsubscribe, send an email to <a href="/cgi-bin/wa?LOGON=A3%3D1712%26L%3DTMSUSERS%26E%3Dbase64%26P%3D162194%26B%3D--_005_DM5PR07MB3852FEC2ACF8C30B34E1D4BFF8330DM5PR07MB3852namp_%26T%3Dtext%252Fplain%3B%2520name%3D%2522Globally%2520check%2520and%2520uncheck%2520Public%2520Access%2520in%2520Objects%2520and%2520Media.txt%2522%26N%3DGlobally%2520check%2520and%2520uncheck%2520Public%2520Access%2520in%2520Objects%2520and%2520Media.txt%26attachment%3Dq%26XSS%3D3" target="_parent" >[log in to unmask]</a> with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.